package com.example.tms.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.tms.entity.EmployeeProject;

public interface EmployeeProjectMapper extends BaseMapper<EmployeeProject> {
    @Select("SELECT * FROM employee_project WHERE emp_id = #{empId} AND is_deleted = 0")
    List<EmployeeProject> selectByEmpId(EmployeeProject employeeProject);

    @Select("SELECT * FROM employee_project WHERE pro_id = #{proId} AND is_deleted = 0")
    List<EmployeeProject> selectByProId(Integer proId);

}
